﻿// Copyright 2009 Mike Geise
// 
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
// 
//     http://www.apache.org/licenses/LICENSE-2.0
// 
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.

namespace Falcon.Core.SqlServer.Repositories.Parameters
{
	using System;
	using System.Data;
	using System.Data.SqlClient;
	using System.Globalization;
	using Falcon.Core.Domain;

	public class UserContactSpecificationParameter : ISpecificationParameter<UserContactSpecification>
	{
		/// <summary>
		/// Populates the specified parameters.
		/// </summary>
		/// <param name="parameters">The parameters.</param>
		/// <param name="specification">The specification.</param>
		public void Populate(SqlParameterCollection parameters, UserContactSpecification specification)
		{
			if (specification.ContactId > 0)
			{
				if (specification.UserId > 0 && !specification.IsModeEnabled)
				{
					parameters.Add("@UserID", SqlDbType.Int).Value = specification.UserId;
				}

				parameters.Add("@ContactID", SqlDbType.Int).Value = specification.ContactId;
			}
			else
			{
				if (specification.UserId > 0)
				{
					parameters.Add("@UserID", SqlDbType.Int).Value = specification.UserId;
				}
			}

			if (specification.Status == null || specification.Status.Length <= 0)
			{
				return;
			}

			var statuses = new DataTable
			{
				Locale = CultureInfo.InvariantCulture
			};

			statuses.Columns.Add(new DataColumn("Status", Type.GetType("System.Int32")));

			for (var i = 0; i < specification.Status.Length; i++)
			{
				var row = statuses.NewRow();

				row["Status"] = (int)specification.Status[i];

				statuses.Rows.Add(row);
			}

			parameters.Add("@Status", SqlDbType.Structured).Value = statuses;
		}
	}
}